package cn.gson.crm.model.mapper;

import cn.gson.crm.model.pojos.*;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface UserMapper {
    //查询所有员工
    public List<User>  selectuser();
    //查询所有部门
    public List<Dept> selectdept();
    //根据部门查询职位
    public List<Role> selectrow(Integer did);
    //修改员工为离职状态
    public void updateyuan(Integer yid);
    //根据员工id查询员工详情
    public List<User>  selectuserxiang(Integer yid);
    //条件查询员工
    public List<User> selectwhere(String where);
    //按入职日期查询
    public List<User> selectDate(@Param("statr") String statr, @Param("endtime") String endtime);
    //查询员工根据姓名
    public List<User> selectyname(String yname);
    //登录查看是否存在
    public List<User> selectfoucun(@Param("yname")String yname,@Param("ypass") String ypass);
    public List<EmployeerVo> selectFonks(@Param("uid") Integer uid);
    public List<String> selectanniu(Integer uid);
    public List<EmployeerVo> firstRouter();
    public List<Sort>  selecctluyou(@Param("uid") Integer uid);
    //查询是否为老板
    public List<User> selectctlaofou(Integer yid);
}
